Budget Department Audit report

This report helps Axiom Budgeting administrators resolve possible mapping errors at the department level by highlighting mapping and process management inconsistencies in the DEPT dimension table before building plan files and starting process management.

When running the report, you can view all of the records or only mapping errors. You can also include all of the budget groups or select one or more specific budget groups.

Cell entries in bold red font indicate a possible incorrect mapping in the DEPT dimension table. The report also includes the number of issues found.

IMPORTANT: This report should show no errors before starting your budget process and building plan files.

Access the report in Axiom Assistant

If you do not have administrative user permissions, access the report using the following path:

Main > Navigation > Explorer > Libraries > Reports Library > Budgeting Utilities > Budget Reconciliation > Budget Department Audit Report.

NOTE: For additional instructions, see Browse the Report Library.

If you have administrative user permissions, access the report using the following path:

Admin > Admin Task Panes > Budget Admin > Budget Reporting > Budget Utilities > Budget Reconciliation > Budget Department Audit Report.

Report columns

The following table lists the columns included in the report and under what conditions they are triggered:

Column	Description
Budgeting Department	Displays the name of the mapped budgeting department. NOTE: The system shows only the first mapped department and does not repeat mapped numbers. If the cell in this column is blank,it uses the same mapped number as the one above it.
Budget Department Description	Displays a brief description of the mapped department.
Original Dept	Displays the original department number. If it is mapped to another department, the system uses a light gray font, and the budget for that department is in the mapped department plan file.
Description	Displays the original description of the department (not the mapped department description).
KHABgtMap Dept	Displays KHABgtMap mapping. A bold red font indicates an incorrect mapping. Combines the data from multiple departments under a single department during plan file creation. Plan file budget data is saved to Budget tables using the department code provided in this column. NOTE: When combining depts, if KHABgtMap is not the same as the original DEPT code, then KHABgtCode must equal the dept code in the KHABgtMap column. Otherwise, a mapping Warning will be provided in the report until the error is resolved.
KHABgtCode Dept	Used to budget multiple departments in one budget plan file. NOTE: KHABgtMap determines the distinct department code used to save the budget data to budget tables.
BudgetGroup	Displays budget group assignment. A bold red font indicates if it is an invalid assignment.
Template Assignment	If this is a current activity, expect either template assign or map department using KHABgtCode. The system uses bold red font to indicate if there is a current year activity in this department, and if it is not mapped or assigned a template. NOTE: This warning does not stop the process but rather serves as an indicator to review it.
TPLOptions	Displays the valid TPLOptions Assignment if a template is assigned. The system uses bold red font in the following situations: The option is an invalid assignment. When NA is entered, indicates that a TPLOptions Assignment is selected when a template name exists in column M.
LaborType	Displays the valid Labor Assignment if a template is assigned. The system uses bold red font if the Labor Assignment is not valid for the specified template.
ShowonList	Displays TRUE if you intend to budget and no configuration issues exist. The system checks for areas where you have the Show on List option set to Yes and the area has configuration issues. FALSE is the preferred outcome.
CurYTD Revenue	Queries the current year activity. If current activity exists, expect either template assign or map Dept via KHABgtCode.
CurYTD Expense	Queries current year activity. If current activity, expect either template assign or map Dept via KHABgtCode.
Warning BudgetGroup	Displays BudgetGroup issues.
Warning Template	Displays setup issues from the Template Assignment column.
Warning KHABgtMap	This column displays the number of KHABgt mapping errors that need to be corrected before building the plan file. KHABgtMap needs to match a valid Dept code. The following images display combining KHABgtCode and KHABgtMap functionality:

If any issues appear, open the Dimension Maintenance utility directly from this report to make adjustments in the DEPT dimension. You can then rerun the Budget Department Audit report to verify you made correct changes.

The Budget Department Audit report is located in the Bud Admin task pane, in the Budget Reporting > Budget Utilities > Budget Reconciliation folder.